Sockso Forum Index Sockso
Personal music server
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Mqsql backend and german umlauts

 
Post new topic   Reply to topic    Sockso Forum Index -> Help
View previous topic :: View next topic  
Author Message
haiti



Joined: 03 Oct 2008
Posts: 16

PostPosted: Tue Jan 20, 2009 2:33 pm    Post subject: Mqsql backend and german umlauts Reply with quote

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
View user's profile Send private message
JTRipper



Joined: 18 Feb 2009
Posts: 13

PostPosted: Fri Feb 20, 2009 12:40 am    Post subject: Reply with quote

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
View user's profile Send private message
JTRipper



Joined: 18 Feb 2009
Posts: 13

PostPosted: Fri Feb 20, 2009 11:54 pm    Post subject: Reply with quote

Ok, removing 'update( " set names utf8 " );' from MySQLDatabase.java did the job for me... Everything working fine now...
Back to top
View user's profile Send private message
mebaris



Joined: 16 Jun 2009
Posts: 2

PostPosted: Tue Jun 16, 2009 6:25 pm    Post subject: Reply with quote

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
View user's profile Send private message
caic



Joined: 24 Jul 2009
Posts: 2

PostPosted: Fri Jul 24, 2009 12:40 pm    Post subject: Reply with quote

Hi,

I'm having de same promblem with Spanish charcacters. Any help?

Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Sockso Forum Index -> Help All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group