Datatables problem with à and î ?

Topic: Datatables problem with "à" and "î" ?

jouvrard pro asked 6 years ago

I use datatables since it's available in MDBootstrap ,but today I notice what seems to be a bug.

I often use accented characters and there is no problem, except with the "à" and the "î" (for the moment).

I tested it in another part of my website (with exactly the same database field) and it works perfectly... except in a Datatable.

Are you aware of a problem like this?

Add comment

Jakub Mandra staff premium answered 6 years ago

0 0 Best answer

Hello, Could you describe how does that problem reveal? Please send us screenshot or copy-paste console errors. For now I can't tell much about that 'bug' (that doesn't occure within my tests, so I think it is specific to environment). Thanks for posting! :) Best regards, Jakub from MDB

Add comment

jouvrard pro answered 6 years ago

0 0 Best answer

I did other tests since yesterday and it seems to come from an other part, but not dataTables. I don't understand why because when I test this elsewhere it works perfectly. So, this problem doesn't come from MDBootstrap or DataTables, I'm sorry. :) May I delete my post?

jouvrard pro commented 6 years ago

I found the solution. If anyone else has this problem, it was because my DB was in utf8mb4_general_ci, and it causes some problems in few SQL requests, it works well with utf8mb4_unicode_ci.

Add comment

Write

Create snippet

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Resolved

Specification of the issue

User: Pro
Premium support: No
Technology: MDB jQuery
MDB Version: -
Device: -
Browser: -
OS: -
Provided sample code: No
Provided link: No

About author

jouvrard

Pro User

898Support score
46Questions 70Answers

1Snippets likes 11Snippets