PokerTracker

It came up while I was playing on Pokerstars...
*********************************
PT Version: 2.17.03b
Error Date: 10/21/2008 23:32
Database Error: 7
Error Text: SQLSTATE = 22P05
ERROR: character 0x8d of encoding "WIN1252" has no equivalent in "UTF8";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'pičo', 1, 8635, 2, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'pičo', 1, 8635, 2, 0, 1, 0 )
*********************************

Open the Utilities > PostgreSQL Settings window. What value is in the "ODBC Entry to use" field?

Ansi

That's the encoding field, I need to know what is selected in the "ODBC Entry to use" field. And that field should be UNICODE not ANSI anyway.

I changed it to UNICODE and its good now, my bad for this...

Thanks!

Its back

for ODBC I have PosteSQL Unicode

open the File > Maintain Database Names window, click the Add button, enter a description, check the "Dflt" box and in the last field choose "Select existing PostgreSQL database". On the window that opens select the PostgreSQL database. Then click OK to save all changes. CLOSE AND REOPEN POKER TRACKER.

Same error

I don't know what else to tell you then. You'll have to edit the hand history file that is causing this error, find the player name which causes it and do a global search/replace to change the name (remove the non-English characters, like changing "pičo" to "pico" and then saving the file and doing the import.