Re: Advantages - if any of - of us ascii7 charset over ascii western european

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702F240F3_at_lnewton.leeds.lfs.co.uk...
> Andrew,
>
> we used to leave our databases at US7ASCII until we started importing
> dumps from German customers and suddenly we were getting duplicate keys
> in tables because there was German and English language text in some
> VARCHAR2 columns. Suffice to say that the accented characters were
> converted to unaccented, and somehow the codes managed to match up in
> the table.
>
> We changed to using an 8 bit character set and all those problems
> vanished.
>
> That's our main advantage - we don't have to worry about the fact we
> have customers all over Europe, Australia etc and can quite happily
> import test dumps from all over.
>
> We might even go to UTF8 soon :o)
>

Strongly recommended, I would say!! (Bear in mind that UTF8 or UTF16 -with various AL codes prefixed to them- are compulsory for 9i databases as their national character sets).

Regards
HJR
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
> -----Original Message-----
> From: calbloke_at_yahoo.com (andrew) [mailto:calbloke_at_yahoo.com]
> Posted At: Tuesday, November 19, 2002 4:51 PM
> Posted To: server
> Conversation: Advantages - if any of - of us ascii7 charset over ascii
> western european
> Subject: Advantages - if any of - of us ascii7 charset over ascii
> western european
>
>
> What , if any, is the advantage of defining a DB characterset as Ascii
> 7-bit (US Ascii) over Ascii 8-bit (western european) ?
>
> Both require a single byte for storage but the 8-bit allows you to
> store umlauts etc correctly
>
> Thanks
>
Received on Tue Nov 19 2002 - 13:16:42 CST