| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Cesar Alvarez <c(dot)alvarezx66(at)gmail(dot)com> |
| Cc: | PGSQL GEneral Mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CHAR SETS |
| Date: | 2007-10-13 17:35:41 |
| Message-ID: | 20071013173541.GA1312@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Oct 13, 2007 at 11:23:41AM -0600, Cesar Alvarez wrote:
> Good day everyone
>
> I got a question, what are the differences of SQL_ASCII and UTF8, witch
> one should i use??
Well, SQL_ASCII means basically that what you put in you get out, but
the DB is going treat it as ASCII, umlauts/etc simply won't be
recognised. UTF8 means the DB will check your data is properly
represented and make an effort to handle case-sensetivity and such
things for you.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Peterson | 2007-10-13 17:41:02 | Re: convert binary string to datum |
| Previous Message | Cesar Alvarez | 2007-10-13 17:23:41 | CHAR SETS |