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 (Cocoa-dev@lists.apple.com) >>> >>> 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 l...@mac.com >> >> _______________________________________________ >> >> Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) >> >> 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 d...@druware.com > _______________________________________________ Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) 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 arch...@mail-archive.com