Page MenuHomePhabricator

MSSQL connection should support special characters in connection info
Open, Needs TriagePublic

Description

I use the ExternalData Extension to query data from my MSSQL Database (mediawiki itself runs on mysql).
SQL Selects with special german characters like äöüß dosn't work, the string get craped.
I insert the line

$connectionInfo['CharacterSet'] = 'UTF-8';

into the file ".\includes\db\DatabaseMssql.php" for the function "open" (for me it is on the line 110).
This fixes my problems with the Data-Select.
There is actual no option for activation of UTF-8 so maybe you can insert an parameter or change the connection to UTF-8 (which is in my oppinion the most needed configuration)

In my Situation i write these question (the character ü goes craped and i get no response from database)

{{#get_db_data: |db=name_of_db |server=name_of_server |from=name_of_table |where=Country='Türkei' |data=...}}

Event Timeline

TomyLee created this task.Feb 24 2016, 7:51 AM
Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald TranscriptFeb 24 2016, 7:51 AM
Goldengide1 updated the task description. (Show Details)
This comment was removed by Goldengide1.

Hi, how can I access the externaldata extension I don't know where to look
Thanks

@Goldengide1: Please see the docs how to check out code from the mediawiki/extensions/ExternalData Git/Gerrit repository, and also for best places to ask general questions. Thanks!

Thanks so much Sir. I will do exactly that

Goldengide1 removed Goldengide1 as the assignee of this task.Apr 12 2017, 8:50 PM
Goldengide1 added a subscriber: Goldengide1.

@Goldengide1: Any news to share? (As you claimed this task.) Anything we can help with?

@Aklapper I was getting errors on the extensions itself but I will report it and get the bug solved asap

Goldengide1 removed Goldengide1 as the assignee of this task.May 23 2017, 3:47 PM
Restricted Application added a subscriber: Liuxinyu970226. · View Herald TranscriptJun 27 2019, 9:14 PM
Krinkle renamed this task from MSSQL Connection doesn't support special characters in query string to MSSQL connection should support special characters in connection info.Jul 23 2019, 10:19 PM
Krinkle added a project: MSSQL.
Restricted Application added a project: Platform Engineering. · View Herald TranscriptJul 23 2019, 10:19 PM