subject:"\[sqlite\] UTF8 question"

Re: [sqlite] UTF8 question

2004-01-12 Thread William M. Droste

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 stri

[sqlite] UTF8 question

2004-01-11 Thread Steven Van Ingelgem

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.