OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » 2 languages in 1 db

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

2 languages in 1 db [message #120452]

Thu, 19 May 2005 17:22

wejder
Messages: 7
Registered: May 2005
Location: Warsaw

Junior Member

how implement polish language in french existing database to work in 2 languages ?

i'd like to take a note that in polish and english are local characters Smile

[Updated on: Thu, 19 May 2005 17:24]

Report message to a moderator

Re: 2 languages in 1 db [message #120704 is a reply to message #120452]

Mon, 23 May 2005 02:10

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

Multi-Language Support IN SINGLE db

I want to create a database with support for the following languages -
US English,
Canadian English,
Spanish
and French

(1) Which character set do I use?

Use UTF8 as database characterset.

(2) Once I use appropriate character set, would I be able to store information in multiple languages in the same row, different columns, say column1=French Name and Column2=Spanish Name?

YES

(3) Will I be able to see multiple lanugage info on screen/reports?

YES

Refer to Oracle SQL Reference documentation for sql function "CONVERT"

CONVERT converts a character string from one character set to another.
Example"

SQL>
SELECT CONVERT('Groß', 'US7ASCII', 'WE8HP') "Conversion" FROM DUAL;

Conversion
----------
Gross

Hope this helps....

Cheers...
NK

Report message to a moderator

Re: 2 languages in 1 db [message #121078 is a reply to message #120704]

Wed, 25 May 2005 17:14

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Maybe a better way to store multiple lang strings is to have a table with 3 cols e.g.

create table x1(msg_id varchar2(12), msg_lang varchar2(4), msg_long varchar2(80));

the PK is on (msg_id, msg_lang )

insert into x1 values('GREET', 'EN', 'English greeting');
insert into x1 values('GREET', 'FR', 'French greeting');

select msg_long into v_msg from x1 where msg_id = 'GREET' and msg_lang = 'EN';

I would also use UTF8 database characterset because it is a superset and will handle anything.

Report message to a moderator

Previous Topic:	10g Installation with 9i db
Next Topic:	how to find port number of isqlplus service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 06:28:50 CST 2025