4
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
5
<link rel="STYLESHEET" type="text/css" href="../pgadmin3.css">
6
<title>Guru Hints</title>
11
<h3>Database encoding</h3>
13
The database <INFO> is created to store data using the SQL_ASCII encoding. This encoding is defined
14
for 7 bit characters only; the meaning of characters with the 8th bit set (non-ASCII characters 127-255) is not defined.
15
Consequently, it is not possible for the server to convert the data to other encodings.
18
If you're storing non-ASCII data in the database, you're strongly encouraged to use a proper
19
database encoding representing your locale character set to take benefit from the automatic conversion to different client encodings
20
when needed. If you store non-ASCII data in an SQL_ASCII database, you may encounter
21
weird characters written to or read from the database, caused by code conversion problems.
22
This may cause you a lot of headache when accessing the database using different
23
client programs and drivers.
26
For most installations, Unicode (UTF8) encoding will provide the most flexible capabilities.