I am not a character set expert. However, I though all characters in EE81S08859P2 were 8 bits, and that it differs from WE8ISO8859P1 in having some bit strings represent characters common to Eastern Europe, vs. the same bit string representing a Western European character. I don't believe it's like UTF8 where an accented character would be represented by 16 bits, 8 for the character and 8 for the accent.
However I do know that a field defined as varchar2(10) will store up to 10 characters no matter if they are 8, 16, 23, or 32-bit. This is different from a field defined with char(10) which can store up to 10 bytes. In a UTF8 database a varchar2(10) field would could store (üéâäàåçêëè) where as a char(10) field could store only (üéâäà) assuming each character requires 16 bits.
Ian MacGregor
Stanford Linear Accelerator Center
[Email Address Removed] Message-----
From: Hartzel, Scott [mailto:[Email Address Removed]
Sent: Thursday, October 31, 2002 9:09 AM
To: LazyDBA.com Discussion
Subject: CZECH Special Characters and EE8ISO8859P2
Hi Gurus,
NT 4.0 SP6
Oracle 8.1.7.0.3
I hope there is someone out there with the answer to this question! Our developers are trying to insert a string of 250 characters into a VARCHAR2 column. The string contains some CZECH special characters. The Database code page is set to EE8ISO8859P2. The init.ora parameter NLS_TERITORY is set to "CZECH REPUBLIC". We are using Merant Data Direct Drivers which do not require the Oracle middleware to be installed on the client machine. The problem is this string is being truncated. My question is this . . . WHY?! Are the Latin-2 CZECH special characters larger than 8 bits? Any insight into this would be helpful. I can not seem to find the right combo of search words to find anything about character size on Metalink.
TIA
Scott Hartzel
Oracle DBA/Developer
Database Engineering
Kronos Incorporated
2 Omni Way
Chelmsford, MA
<<...OLE_Obj...>>
"The degree of normality in a
database is inversely proportional
to that of its DBA" -- unknown
--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page