[Solar-talk] UTF-8

[Rodrigo Moraes]

On 7/20/06, Paul M Jones wrote:
> I probably won't put it in the standard adapters just yet; at least,
> not until we have a way of doing it that extends across all
> adapters.  I want them all to work as close to identically as
> possible (and they're pretty near identical right now).

For PostgreSQL 7.3.x, 7.4.x, 8.0.x and 8.1.x, it seems to be as simple
as for MySQL 4.1.x:

    $pdo->exec("SET CLIENT_ENCODING TO '$charset'");

I've looked everywhere and found no charset command for Sqlite, and
perhaps because there isn't any. I read that SQLite must be compiled
with utf-8 support, and it will handle the charset on-the-fly. So
there is nothing that would affect those that doesn't use UTF-8 or a
different charset. Can anybody confirm this?

MS-SQL: it also seems that the charset can't be set at runtime. So
it's up to the user adhere to the same charset set in the database
initialization. Well, this is a guess.

regards,
rodrigo moraes / brazil