FTP | CCD | Buscar | Trucos | Trabajo | Foros |
|
Registrarse | FAQ | Miembros | Calendario | Guía de estilo | Temas de Hoy |
|
Herramientas | Buscar en Tema | Desplegado |
|
#1
|
||||
|
||||
¿Qué versión de Delphi usas?
// Saludos |
#2
|
|||
|
|||
10.2 Tokyo
|
#3
|
||||
|
||||
Comprueba qué "encoding" tiene.
PRAGMA encoding; PRAGMA encoding = "UTF-8"; PRAGMA encoding = "UTF-16"; PRAGMA encoding = "UTF-16le"; PRAGMA encoding = "UTF-16be"; In first form, if the main database has already been created, then this pragma returns the text encoding used by the main database, one of "UTF-8", "UTF-16le" (little-endian UTF-16 encoding) or "UTF-16be" (big-endian UTF-16 encoding). If the main database has not already been created, then the value returned is the text encoding that will be used to create the main database, if it is created by this session. The second through fifth forms of this pragma set the encoding that the main database will be created with if it is created by this session. The string "UTF-16" is interpreted as "UTF-16 encoding using native machine byte-ordering". It is not possible to change the text encoding of a database after it has been created and any attempt to do so will be silently ignored. Once an encoding has been set for a database, it cannot be changed. Databases created by the ATTACH command always use the same encoding as the main database. An attempt to ATTACH a database with a different text encoding from the "main" database will fail. |
#4
|
|||
|
|||
El pragma de la base es UTF-8
|
#5
|
|||
|
|||
Rectifico, el econding que devuelve el PRAGMA es UTF-8
|
#6
|
||||
|
||||
Pues entonces, por algún motivo, estás enviando texto que no es utf8 a la base de datos.
¿Has probado desde un software externo? (sqlite studio admin, sqliteman, etc.? |
#7
|
|||
|
|||
Cuando ejecuto dentro del Admin de SQLite funciona bien, bueno, seguiré revisando a ver que puede ser, por el momento he optado por eliminar los acentos y otros caracteres del string que paso desde Delphi.
|
|
|
Temas Similares | ||||
Tema | Autor | Foro | Respuestas | Último mensaje |
Lazarus: TStringList.LoadFromFile error cuando la ruta tiene eñes/acentos | euMesmo | Lazarus, FreePascal, Kylix, etc. | 12 | 07-03-2015 00:19:38 |
problema con eñes y tildes | jarto | MySQL | 1 | 28-04-2005 15:01:47 |
Acentos y eñes | llonigualker | Varios | 3 | 20-11-2004 14:25:35 |
UPPER, UpperCase con eñes, tildes ... | Tomás | Firebird e Interbase | 3 | 15-01-2004 18:24:24 |
Ordernar a acentos y eñes (tablas dbase) | Jose_Pérez | SQL | 2 | 17-11-2003 15:49:20 |
|