Re: Unicode and Oracle

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 30 Nov 2005 08:06:37 GMT
Message-ID: <1133337996.496893@proxy.dienste.wien.at>

Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:
>> The table names must be in the database character set and not in the
>> national character set, however.
>>
>> So it should be:
>>
>> EXECUTE IMMEDIATE 'SELECT * FROM "MYSCHEMA"."MYUNICODETABLENAME"'
>>
>> and not
>>
>> EXECUTE IMMEDIATE N'SELECT * FROM MYSCHEMA.MYUNICODETABLENAME'
>>
>> Yours,
>> Laurenz Albe

> 
> Which is a bad idea...
> Once a table "MyUniCodeTablename" is created you rmust always refer to
> it as "MyUniCodeTablename" - case and quotes included.

I never said it was a good idea to use anything but ASCII7 for table names.

Yours,
Laurenz Albe Received on Wed Nov 30 2005 - 02:06:37 CST