Re: Characterset problem with Oracle

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Mon, 13 Sep 2004 14:09:19 -0400
Message-ID: <ci4noi$5d3$1@newslocal.mitre.org>

Christian Antognini wrote:
> **** Post for FREE via your newsreader at post.usenet.com ****
>
> Hi
>
> "Sunil" <zunilp_at_gmail.com> wrote in message
> news:8e0c3fab.0409122303.4ab98410_at_posting.google.com...
>
>

>>Can I change it directly to WE8MSWIN1252?

>
>
> Before any change in the char set you should check with "csscan" if it is
> possible.
>
>

>>The client also I have to change to WE8MSWIN1252?

>
>
> As I wrote some days ago... yes.
>
>

>>Will it affect the existing data in any form?

>
>
> Since the two char set are different, you could have some problems.
> Therefore an analysis with "csscan" should be performed.
>
>

>>Will UTF8 charactesrset takes care all characters including this
>>Word/Excel or Windows specific characters?

>
>
> Yes. But don't underestimate the overhead caused by UTF8... i.e. if you can
> solve your problem with WE8MSWIN1252, just use it.
>
>
> Chris
>
>
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Chris,

Would you care to expand upon the overhead issue associated with UTF8. I would expect that with Java and other apps that deal with UTF natively that there might be less overhead, overall (client + server).

--Peter Received on Mon Sep 13 2004 - 13:09:19 CDT