Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-15 Thread Trevor DeVore
On Tue, Dec 14, 2010 at 4:40 PM, Web Admin Himalayan Academy < ka...@hindu.org> wrote: > On 12/14/10 2:30 AM, Trevor DeVore wrote: > >> Personally I configure PostgreSQL to use UTF-8. I then encode any strings >> I >> insert and decode any strings I get out. >> >> I checked on our server and I h

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-14 Thread Bob Sneidar
That whole affair at the Tower of Babel really threw a wrench into the works didn't it? We should all just go back to using the original language: English! HAH HAH! Bob On Dec 14, 2010, at 1:40 PM, Web Admin Himalayan Academy wrote: > On 12/14/10 2:30 AM, Trevor DeVore wrote: >> Personally I

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-14 Thread Web Admin Himalayan Academy
On 12/14/10 2:30 AM, Trevor DeVore wrote: Personally I configure PostgreSQL to use UTF-8. I then encode any strings I insert and decode any strings I get out. I checked on our server and I have all the databases set for UTF-8... I'll try some tests... using uniEncode. I presume this needs to

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-14 Thread Trevor DeVore
On Mon, Dec 13, 2010 at 4:10 PM, Bob Sneidar wrote: > BTW, Trevor, does sqlYoga resolve this issue internally? If so it would > make a really great selling point for sqlYoga! No. I considered allowing one to set the encoding the database should use along with the encoding the strings would be p

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-13 Thread Sivakatirswami
On 12/13/10 11:04 AM, Bob Sneidar wrote: A search of the LiveCode dictionary for encode reveals the uniEncode function. This might be what you are looking for. BTW (and please nobody hate me for saying so) (and this is not directed at the poster or anyone in particular) a LOT of enquiries on

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-13 Thread Bob Sneidar
I also found this. Of particular interest is the section on double dollar sign quoting: 4.1.2.4. Dollar-Quoted String Constants While the standard syntax for specifying string constants is usually convenient, it can be difficult to understand when the desired string contains many single quote

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-13 Thread Bob Sneidar
BTW, Trevor, does sqlYoga resolve this issue internally? If so it would make a really great selling point for sqlYoga! Bob On Dec 13, 2010, at 12:00 PM, Sivakatirswami wrote: > I'm a dbase - sql newbie when it comes to actually writing a web front end > for capturing and inserting data into a

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-13 Thread Bob Sneidar
A search of the LiveCode dictionary for encode reveals the uniEncode function. This might be what you are looking for. BTW (and please nobody hate me for saying so) (and this is not directed at the poster or anyone in particular) a LOT of enquiries on this list I find the answers for by doing

Re: OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-13 Thread Bob Sneidar
If I am not mistaken, your database columns need to be defined as UTF16 or something along that order. I don't believe UTF8 will support foreign characters. I may be mistaken on the type of formatting (I never need to use "foreign" characters so I have no actual experience) but I think the princ

OT: Problems with Inserting Odd Characters into PostGreSQL

2010-12-13 Thread Sivakatirswami
I'm a dbase - sql newbie when it comes to actually writing a web front end for capturing and inserting data into a database. I can do code to read and use data, no problem, but this is my very first project where I actually all on my own without Andre's help, write a front end to accept input