I am having difficulties getting my dives imported into MySQL for use with phpDivingLog 3.0. I run the export function in Diving Log 5.0, it completes, but when I look in phpDivingLog or even directly in MySQL, there's nothing there. I have exported it to a file and am able to see all of my dives in the resulting file.
I tried to manually import the file using phpMyAdmin and got the following error:
SQL query:
CREATE TABLE Brevets(
ID int( 11 ) AUTO_INCREMENT ,
Brevet varchar( 255 ) default '',
Org varchar( 255 ) default '',
CertDate date default NULL ,
Number varchar( 255 ) default '',
Instructor varchar( 255 ) default '',
InstructorNo varchar( 255 ) default '',
Scan1Path varchar( 255 ) default '',
Scan1 blob default NULL ,
Scan2Path varchar( 255 ) default '',
Scan2 blob default NULL ,
UUIDchar( 36 ) default '',
Updated date default NULL ,
SortOrd int( 11 ) default NULL ,
PRIMARY KEY ( ID )
) ENGINE = MYISAM DEFAULT CHARSET = ANSI;
MySQL said: Documentation
#1115 - Unknown character set: 'ANSI'
Any assistance would be greatly appreciated!
MySQL import problems
Re: MySQL import problems
Either switch in the export settings to UFT-8 encoding, or select ANSI encoding during import in phpMyAdmin. Both encoding settings have to match, then it should work.
Re: MySQL import problems
I must have missed that in the Advanced Settings the first time. I changed the export to UTF-8 and it works now. Thank you!!