On Wed, 14 Apr 2004, Fabien COELHO wrote: > printf("SELECT * FROM foo WHERE field1 = '%s'", > latin1_to_database_encoding(...));
And how do you do this if the database encoding is latin2? You can not convert latin1 to latin2. The specification was written like this to handle things like latin1 strings in latin2 databases, or latin1 in a database that otherwise only uses ascii. The intention is good, but the specification is not perfect in any way. -- /Dennis Björklund ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster