Results 1 to 3 of 3
  1. #1
    black300 is offline Member
    Join Date
    Apr 2011
    Posts
    3
    Rep Power
    0

    Exclamation problem in java import

    hi all !!
    i did an application that makes me able to import Excel sheets into MySQL data base from Java and it works !! but the problem that my database has some French letters like ",, and " so it doesn't recognize them instead its replaced by a small cube or interrogation in the middle of the word i changed my var-char type to UTF8 and General Ci for all my fields and the problem still existing so if anyone have the solution or an idea i will be thankful !! :)

  2. #2
    ozzyman's Avatar
    ozzyman is offline Senior Member
    Join Date
    Mar 2011
    Location
    London, UK
    Posts
    797
    Blog Entries
    2
    Rep Power
    4

    Default

    parse the excel file, remove those characters or replace them using regular expressions

  3. #3
    black300 is offline Member
    Join Date
    Apr 2011
    Posts
    3
    Rep Power
    0

    Question

    no sir my database is in French so it must be perfect and containing like these characters even i have some queries test including words having "" for example and it works and my data is full of them only i don't know why in the import process can't read them

Similar Threads

  1. Replies: 0
    Last Post: 04-02-2011, 11:22 AM
  2. Problem import query.*
    By teaicky in forum New To Java
    Replies: 4
    Last Post: 02-06-2011, 12:09 AM
  3. import problem
    By anki.gulsvart in forum Networking
    Replies: 9
    Last Post: 10-16-2009, 08:03 PM
  4. Replies: 6
    Last Post: 09-11-2009, 01:34 AM
  5. Import java.io.* problem
    By DD70 in forum New To Java
    Replies: 3
    Last Post: 07-28-2009, 11:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •