Re: Utf8 Oracle

My experience is that WE8ISO8859P15 covers almost all of europe as well as ASCII based special characters. I normally suggest using UTF8 or UTF16 only if a customer would want to store multi-byte Asian characters or when there is a mix of ASCII based characters and EBCDIC based characters. While cp1250 is just Latin-1 in unicode parlance it is supported by ISO8859 characterset and cp1252 being another ascii based codeset, will possibly be supported by WE8ISO8859P15 (which supports the Euro and the Trade Mark symbols which are part of the cp1252 codeset).

That being said, I would like to emphasize that UTF8 is by far the quickest answer when it comes to choosing characterset but it may not always the best pratice. I have seen applications fail because of the fact that UTF8 converts single byte characters to double byte ones if these are between ASCII128 and ASCII255. If you can provide for that, UTF8 is surely the most convenient solution.

//tc

"willevolve" <member27377_at_dbforums.com> wrote in message news:2715670.1049213250_at_dbforums.com...
>
> o.k.
>
> but,
>
> if You want to cover Europe & cp1250/cp1252 (easten europe), You can do
> it only with utf8.
>
> In ORACLE manuals I notice some diferences between utf8 and utf-8????
>
>
> mb
>
> --
> Posted via http://dbforums.com
Received on Tue Apr 01 2003 - 22:24:12 CEST