Re:

Hiroshi Saito wrote:

>From: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
>
>
>
>>Hiroshi Saito wrote:
>>
>>
>>
>>>Hmm..
>>>Is it a specific code or all code?
>>>However,
>>>Will you absorb all the bugs of PostgreSQL?
>>>
>>>
>>>
>>>
>>This is not a bug of PostgreSQL, nor of pgAdmin.
>>SQL_ASCII database *should* contain only 7bit ascii characters. If you
>>use 8-bit characters, conversion is unpredictable (well, it *is*
>>predictable, but probably not what you'd like to see)
>>
>>
>
>It isn't understood.
>Shouldn't put it in SQL_ASCII.
>Database comes to return the result which made a mistake.
>Or, do you use 256(2^8=256) ASCII?
>

The DB will store 8 bit per character, regardless of the db encoding.
When it comes to conversion, only 7 bits are valid, if you tell the
backend "this is ASCII data". Your fault, if it actually isn't.

Regards,
Andreas