[GENERAL] Cannot store special chars using c lib

2012-03-22 Thread Alexander Reichstadt
Hi, I need to be able to store special chars, German Umlaute, in my tables. This works when using pgPHPAdmin to store the same value to the same field. But when using the c-library it doesn't, fields stored are garbled. I checked using \l to see what encoding the database is which is UTF8,

Re: [GENERAL] Cannot store special chars using c lib

2012-03-22 Thread Alexander Reichstadt
Sorry, there is a copy-paste error, actually the code really is: const char *cString = [sql cStringUsingEncoding:defaultEncoding]; if (cString == NULL) { blablabla //This just catches cases where cString failed to encode. } res = PQexec(pgconn, cString); Am 22.03.2012 um 09:02

Re: [GENERAL] Cannot store special chars using c lib

2012-03-22 Thread Alexander Reichstadt
Hi, I found out that apparently in PGSQLKit there is an error in PQescapeStringConn or the way it is being used. From the docu I take it this is to prevent SQL injection attacks. I removed any processing and it turned out the issue ceases, all works fine. The call is here: -(NSString

Re: [GENERAL] Cannot store special chars using c lib

2012-03-22 Thread Albe Laurenz
Alexander Reichstadt wrote: I need to be able to store special chars, German Umlaute, in my tables. This works when using pgPHPAdmin to store the same value to the same field. But when using the c-library it doesn't, fields stored are garbled. I checked using \l to see what encoding the

Re: [GENERAL] Cannot store special chars using c lib

2012-03-22 Thread Alexander Reichstadt
Thanks, Albe, I had checked this, too, and it was ok. I already posted the solution to the board. It was an error due to an incorrect conversion between an object-instance and a char. It works now. Am 22.03.2012 um 12:50 schrieb Albe Laurenz: Alexander Reichstadt wrote: I need to be able to