Re: [sqlite] ISO-8859-1

[Igor Tandetnik]

"Igor Tandetnik"  wrote in
message news:gvjb4m$hc...@ger.gmane.org
> "Wili"  wrote in
> message news:23741187.p...@talk.nabble.com
>> it is possible using charset ISO-8859-1 in sqlite?
>
> No, not really. Convert your strings to UTF-8 before passing them to
> SQLite, and to whatever encoding you want when getting them out.

Or to/from UTF-16. Might be easier - all you have to do to convert 
ISO-8859-1 to UTF-16 is zero-expand each byte to a 16-bit value, and to 
convert back, just drop those extra zeros. Not that converting to/from 
UTF-8 is much more complicated.

Igor Tandetnik



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ISO-8859-1

[Wili]

Hi Igor,

thx for fast awnser!

lg
\^/ili

-- 
View this message in context: 
http://www.nabble.com/ISO-8859-1-tp23741187p23741440.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ISO-8859-1

[Igor Tandetnik]

"Wili"  wrote in
message news:23741187.p...@talk.nabble.com
> it is possible using charset ISO-8859-1 in sqlite?

No, not really. Convert your strings to UTF-8 before passing them to 
SQLite, and to whatever encoding you want when getting them out.

Now, you could probably get away with storing ill-formed UTF-8 strings 
(which is what ISO-8859-1 strings are, as far as SQLite is concerned), 
as long as all you do is put them into the database and get them out 
later. Comparing them, calling things like length() or substr() on them, 
searching them with LIKE operator and so on would likely produce 
incorrect results. All in all, it's a bad idea, don't do it if you could 
possibly avoid it.

Igor Tandetnik



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ISO-8859-1

[Wili]

Hello,

it is possible using charset ISO-8859-1 in sqlite?

lg
\^/ili
-- 
View this message in context: 
http://www.nabble.com/ISO-8859-1-tp23741187p23741187.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ISO-8859-1 (Latin1) Support in Sort Order

[Vitor]

Hello,

I would like to know if there's some working running to provide correct
sorting method for ISO-8859-1 (Latin1) (eg. 'Á').

If no, i can contribute with "C" code to do it.

Regards,

Vitor


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