Hi, sorry to hear that, but great to meet you here!! Let's catch up off list.
Alex
Am 22.03.2012 um 14:20 schrieb Andy 'Dru' Satori:
> Sorry I didn't see this, I was KO'd by the pollen and seasonal allergies.
> Yes this is an issue with PGSQLkit, I have confirmed it and will be
> committing a change today based upon yours to address this. Thanks for patch!
>
> --
> Andy 'Dru' Satori
>
> On Thursday, March 22, 2012 at 6:55 AM, Alexander Reichstadt wrote:
>
>> The issue was in PGSQLKit.
>>
>> -(NSString *)sqlEncodeString:(NSString *)toEncode
>> {
>>
>> //size_t result;
>> int error;
>> char *sqlEncodeCharArray = malloc(1 + ([toEncode length] * 2)); // per the
>> libpq doc.
>> const char *sqlCharArrayToEncode = [toEncode
>> cStringUsingEncoding:defaultEncoding];
>> size_t length = strlen(sqlCharArrayToEncode);
>> PQescapeStringConn ((PGconn *)pgconn, sqlEncodeCharArray,
>> (const char *)[toEncode cStringUsingEncoding:defaultEncoding],
>> length, &error);
>> //This is bad
>> // NSString *encodedString = [[[NSString alloc]
>> initWithFormat:@"%s",sqlEncodeCharArray] //autorelease];
>> //Instead use
>> NSString *encodedString = [NSString stringWithCString:sqlEncodeCharArray
>> encoding:defaultEncoding];
>>
>> free(sqlEncodeCharArray);
>> return encodedString;
>> }
>>
>>
>>
>>
>> Am 22.03.2012 um 09:09 schrieb Alexander Reichstadt:
>>
>>> Hi,
>>>
>>>
>>> for a couple of reasons we migrated our project from mysql to postgres
>>> using PGSQLKit.
>>>
>>> But we are experiencing problems storing UTF8 data. So far we checked the
>>> database to be able to store UTF8. When using pgPHPAdmin to store values
>>> with German Umlaute it works. When using PGSQLKit chars get garbled.
>>>
>>> The following code stores the values:
>>>
>>>
>>> const char *cString = [sql cStringUsingEncoding:NSUTF8StringEncoding];
>>> if (cString == NULL)
>>> {
>>> self.errorDescription = [NSString stringWithFormat:@"ERROR: execCommand
>>> could not be losslessly converted to c string: %@", sql];
>>> [self appendSQLLog:[NSString stringWithFormat:@"%@\n",
>>> self.errorDescription]];
>>> return NO;
>>> }
>>> res = PQexec(pgconn, cString);
>>>
>>> Both sides seem correct, server as well as client, so I am not sure what
>>> the issue might be.
>>>
>>> Any ideas?
>>>
>>> Thanks
>>> Alex
>>> _______________________________________________
>>>
>>> Cocoa-dev mailing list ([email protected])
>>>
>>> Please do not post admin requests or moderator comments to the list.
>>> Contact the moderators at cocoa-dev-admins(at)lists.apple.com
>>>
>>> Help/Unsubscribe/Update your Subscription:
>>> https://lists.apple.com/mailman/options/cocoa-dev/lxr%40mac.com
>>>
>>> This email sent to [email protected]
>>
>> _______________________________________________
>>
>> Cocoa-dev mailing list ([email protected])
>>
>> Please do not post admin requests or moderator comments to the list.
>> Contact the moderators at cocoa-dev-admins(at)lists.apple.com
>>
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/cocoa-dev/dru%40druware.com
>>
>> This email sent to [email protected]
>
_______________________________________________
Cocoa-dev mailing list ([email protected])
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com
This email sent to [email protected]
