Re: How to use cp855 endoded text in a database?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 00:00:19 +0000 (UTC)

 (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/techinfo/productdoc/2000/books.asp