Character error with SQL
#1
Is there something that can be done about this:

xml:
2020-01-18 00:32:42.222 T:9472 ERROR: SQL: [MyMusic72] Undefined MySQL error: Code (1366)
Query: INSERT INTO song (idSong,idAlbum,idPath,strArtistDisp,strTitle,iTrack,iDuration,iYear,strFileName,strMusicBrainzTrackID, strArtistSort, iTimesPlayed,iStartOffset, iEndOffset,lastplayed,rating,userrating,votes,comment,mood,strReplayGain) values (NULL, 19835, 81974, 'Kate Bush', '𝜋', 65538, 369, 2005, '1.02 - 𝜋.flac','c1983e4d-cc94-4f11-9716-8fc7851494cc',NULL,0,0,0,NULL, 0.0, 0, 0,'Toshiba-EMI Limited TOCP-66474', '', '-2.700,1.000,-2.380,1.000')
2020-01-18 00:32:42.223 T:9472 ERROR: musicdatabase:unable to addsong (INSERT INTO song (idSong,idAlbum,idPath,strArtistDisp,strTitle,iTrack,iDuration,iYear,strFileName,strMusicBrainzTrackID, strArtistSort, iTimesPlayed,iStartOffset, iEndOffset,lastplayed,rating,userrating,votes,comment,mood,strReplayGain) values (NULL, 19835, 81974, 'Kate Bush', '𝜋', 65538, 369, 2005, '1.02 - 𝜋.flac','c1983e4d-cc94-4f11-9716-8fc7851494cc',NULL,0,0,0,NULL, 0.0, 0, 0,'Toshiba-EMI Limited TOCP-66474', '', '-2.700,1.000,-2.380,1.000'))

Is the problem the character in the filename?
Reply


Messages In This Thread
Character error with SQL - by HeresJohnny - 2020-01-18, 02:48
RE: Character error with SQL - by Klojum - 2020-01-18, 07:59
RE: Character error with SQL - by HeresJohnny - 2020-01-18, 12:29
RE: Character error with SQL - by black_eagle - 2020-01-18, 08:50
Logout Mark Read Team Forum Stats Members Help
Character error with SQL0