How to use cp855 endoded text in a database?

Hello,
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
Tomislav
If you are having trouble specifying the collation for the particular field
or using the 8-bit encoding, you might have to convert to the IMAGE data
type, which excepts binary data. You would then need to pass and retreive
the information as a bit stream, like using the ADO Stream object.
Hope this helps.
Sincerely,
Anthony Thomas

<tomislav.markovski@.gmail.com> wrote in message
news:1103903500.132330.54060@.z14g2000cwz.googlegro ups.com...
Hello,
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
Tomislav
|||(tomislav.markovski@.gmail.com) writes:
> I'm trying to enter a text encoded in cp855 in a table field which must
> be defined as char. The cp855 encoding is 8-bit encoded text. This
> text, will then be transfered into a POS terminal and display localized
> text. I'm having problems settings up the correct collation and the
> method for entering the text in a char field.
> Can anyone help me please?
This looks difficult. There does not seem to be any collation based on
CP855. It is possible that a Cyrillic collation would them, and you would
then have to place your bets on ANSI/OEM conversion when outputting the
data. If your input is in CP855 as well, then the ANSI/OEM conversion
mus work in both direction, and be round-trip. Unfortunately, this is
not always the case with ANSI/OEM conversions.
Anothy Thomas's idea of using binary somewhere on the way, may be worth
pursuing.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp