Re: UNICODE information - Mailing list pgadmin-hackers

From Dave Page
Subject Re: UNICODE information
Date
Msg-id AA30E7BCCA5C1D4E88A231900F8325C00B2A@dogbert.vale-housing.co.uk
Whole thread Raw
In response to UNICODE information  (Jean-Michel POURE <jmpoure@axitrad.com>)
List pgadmin-hackers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jmpoure@axitrad.com]
> Sent: 26 September 2001 11:24
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] UNICODE information
>
>
> Hello all,
>
> A) UNICODE is just a mapping between fonts. Example :
>
> 1) go to http://www.unicode.org/iuc/iuc10/x-utf8.html
> In your browser, view source code. The encoding is set to
> "charset=UTF-8".
>
> 2) Now, use the command "Save as" and choose "Windows
> Western" encoding. Save the file on your computer. Open it
> and view source code. The encoding
> is set to "charset=windows-1252".
>
> Normally, the display in (1) should be the same as (2).
> This shows that UNICODE is not a font but a mapping system
> (comparable to
> an index).
>
> B) Requirements
> The requirements for good UNICODE compatibility are:
>
> 1) An up-to-date Unicode transcoding system.
> Windows 95, 98, NT, 2000, XP, IE5 and Netscape Navigator
> include their own
> transcoders.
> For what I have read Windows 95 and 98 transcoders cannot be
> trusted. This means data entered from pgAdmin II running on
> Workstation A (W95)
> ***could*** display differently on Workstation B (Win2000).

OK.

> 2) A Unicode compatible font installed in system.
> The list of Unicode fonts can be found on
> http://www.hclrss.demon.co.uk/unicode/fonts.html
> Examples of IE5 fonts are :
>  > Japanese : MS Gothic,
>  > Korean : Gulim Che
>  > Chinese simplified : MS Hei, MS Song
>  > Chinese traditional : MingLiU

OK.

> 3) Visual Basic SP4+ controls
> For what I read, only VB SP4+ controls support UNICODE.
> VB prior to SP4 could only DISPLAY, not INPUT (Ahhhhh!!!!!).
> VB SP4+ can do both (hopefully, never worked under VB for
> localization, I
> am not mad).

So, my understanding from this is if we let the user select their font then
it should work as we're using SP5?

> 4) Probably ODBC special settings
> I don't know. Any idea?

I think Hiroshi anwered this. BIG5(?) and others required the multibyte
enabled driver, Unicode, ASCII & EUC_* just use the standard driver and
maybe an envvar.

> For what I know, we can only go for testing and validate one
> language after
> another with beta testers.

Agreed.

Dave.

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Foreign key modification
Next
From: Jean-Michel POURE
Date:
Subject: ALTER TABLE DROP CONSTRAINT