| View previous topic :: View next topic |
| Author |
Message |
haiti
Joined: 03 Oct 2008 Posts: 16
|
Posted: Tue Jan 20, 2009 2:33 pm Post subject: Mqsql backend and german umlauts |
|
|
I got a new problem as I tried to use MySql for my collection. With the most songs it is working. But last week I bought the new Farin Urlaub CD called "Die Wahrheit übers Lügen". I got two CD´s . After I rip the cd´s i had two directories called "Die Wahrheit übers Lügen (großes Album)" and "Die Wahrheit übers Lügen (kleines Album)". Sockso scans this directories but after this I only can see the cd and the songs out of "kleines Album". I tried several things with locales and the linux.sh, and renaming the Directories in "Die Wahrheit uebers Luegen (grosses Album)". Nothing helps. And then I found that Sockso also didn´t show me any Album of my "Ärzte" collection (about 18 CD´s). In the next step I tried the buildin database. With this databaseengine sockso show me all my songs.
Now I changed back to the build in database engine and I can reach every song of my collection.
Maybe Sockso use in the build in engine only the directory names and song names and MySql uses the MP3 Tags?
I wrote this message weeks before. Since then I tried the newer version of sockso but there is still this failure. Songs with german umlauts will not subscripted if I use Mysql as database engine. |
|
| Back to top |
|
 |
JTRipper
Joined: 18 Feb 2009 Posts: 13
|
Posted: Fri Feb 20, 2009 12:40 am Post subject: |
|
|
same problem for me. This seems to be some UTF-8 related stuff...
After slightly modifying the source code, i got the error message:
com.pugh.sockso.music.DBCollectionManager.addTrack(Unknown Source): java.sql.SQLWarning: Incorrect string value: '\xFCr in ...' for column 'name' at row 1 |
|
| Back to top |
|
 |
JTRipper
Joined: 18 Feb 2009 Posts: 13
|
Posted: Fri Feb 20, 2009 11:54 pm Post subject: |
|
|
| Ok, removing 'update( " set names utf8 " );' from MySQLDatabase.java did the job for me... Everything working fine now... |
|
| Back to top |
|
 |
mebaris
Joined: 16 Jun 2009 Posts: 2
|
Posted: Tue Jun 16, 2009 6:25 pm Post subject: |
|
|
I have to Problem too but i dont find the MYSql*.java , i have the newest version of sockso.
If an Artist or an Titel have an german Umlaut (ä,ö,ü,ß) the File dont add to my MySql Database.
Sry for my bad english |
|
| Back to top |
|
 |
caic
Joined: 24 Jul 2009 Posts: 2
|
Posted: Fri Jul 24, 2009 12:40 pm Post subject: |
|
|
Hi,
I'm having de same promblem with Spanish charcacters. Any help?
Thanks! |
|
| Back to top |
|
 |
|