SQLite will store anything UTF-8 or ANSI as long as its null terminated and escaped for '. The only place where encoding makes a difference is in functions like length.


Will


Steven Van Ingelgem wrote:


If I have a table like:

CREATE TABLE routing (
  FIELD1 VARCHAR(40)
);

what if I get a string which is in ANSI = 40chars, but in UTF8 > 40chars? (for example because it uses ü and such characters...)
Does it get stored correctly?





G00fy, (aka KaReL, aka Steven)


Main Webpage : http://komma.cjb.net
CQ Database  : http://lid.fragland.net/
ICQ #        : 35217584
MSN          : [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to