Subject | charsets |
---|---|
Author | Gediminas |
Post date | 2004-01-08T16:52:52Z |
stuck on a charset problem: created DB using Unicode (Unicode_FSS) as
a way to store lithuanian & other languages national symbols.
Recently have tried to move to windows-1257 (win1257) & ISO8859-13
charsets. What was a suprise to find out, that using such charsets
lithuanian symbols can't be saved into database. Everytime I got
error, stating that arithmetic overflow .... bla bla bla ... or string
truncation, cann't transliterate character between character sets.
But I use lithuanian charset freely on windows - it's win 1257 if I'm
right. So, ISO8859-13 charset must accept national symbols (ISO8859-13
& windows-1257 charsets differ only in 3 punctuation symbols)...
Any suggestions, how to move from the unicode into iso8859-13/win1257
charset?
creating db set default character to none; using F1.5 rc8, Win98SE,
For example have tried to use such domain (without a luck):
CREATE DOMAIN "Char24_lt" AS
VARCHAR(24) CHARACTER SET ISO8859_13
COLLATE ISO8859_13
a way to store lithuanian & other languages national symbols.
Recently have tried to move to windows-1257 (win1257) & ISO8859-13
charsets. What was a suprise to find out, that using such charsets
lithuanian symbols can't be saved into database. Everytime I got
error, stating that arithmetic overflow .... bla bla bla ... or string
truncation, cann't transliterate character between character sets.
But I use lithuanian charset freely on windows - it's win 1257 if I'm
right. So, ISO8859-13 charset must accept national symbols (ISO8859-13
& windows-1257 charsets differ only in 3 punctuation symbols)...
Any suggestions, how to move from the unicode into iso8859-13/win1257
charset?
creating db set default character to none; using F1.5 rc8, Win98SE,
For example have tried to use such domain (without a luck):
CREATE DOMAIN "Char24_lt" AS
VARCHAR(24) CHARACTER SET ISO8859_13
COLLATE ISO8859_13