projectnami icon indicating copy to clipboard operation
projectnami copied to clipboard

Update class-wpdb.php to support NVARCHAR

Open srutzky opened this issue 2 years ago • 2 comments

This fixes #515 .

Add "N" prefix to quoted string substitution when preparing SQL for execution. This will change string literals to be interpreted as NVARCHAR (i.e. Unicode / UTF-16) instead of VARCHAR (i.e. an 8-bit encoding, which changes all characters not in the associated code page to "?"s).

PLEASE NOTE: I don't have time to test this fix. If it helps, there are some notes on what should be tested in PR #422 .

srutzky avatar Nov 21 '23 06:11 srutzky

Tested in 6.5.3 and appears to work without issue.

LarnuUK avatar Jul 11 '24 15:07 LarnuUK

Retested in 3.8.1 and working as expected.

LarnuUK avatar Jun 30 '25 14:06 LarnuUK