Michael Ludwig schrieb am 06.01.2012 um 16:12 (+0100):

> Mark Rotteveel schrieb am 06.01.2012 um 15:49 (+0100):
> > On Fri, 6 Jan 2012 15:11:26 +0100, Michael Ludwig <milu71@...>
> > wrote:
> > > No, it's not; Œ and œ are missing from ISO-8859-1 (Latin1).

> > You are right, missed that one :) They are included in the Microsoft
> > 'version' of ISO-8859-1: Windows-1252. Funny thing is that
> > ISO-8859-15 contains all characters in Windows-1252, but some of
> > them are at different byte encodings. Characterset are annoying :)
>
> Hehe, so many people blaming Microsoft, but they do get stuff right,
> against all standards.

> SQL> create table tc1 (a int, b varchar(10) character set ISO8859_1);
> SQL> create table tc2 (a int, b varchar(10) character set ISO8859_15);
> Statement failed, SQLSTATE = HY004
> Dynamic SQL Error
> -SQL error code = -204
> -Data type unknown
> -CHARACTER SET ISO8859_15 is not defined

CREATE TABLE tms ( c VARCHAR(10) CHARACTER SET WIN1252 );

Here you go, that's your best pick for Western European languages.

Unless you're serious about Polish, in which case you have to go
Unicode.

--
Michael Ludwig