Viewing 15 posts - 16 through 30 (of 645 total)
might be worth checking filenames of attachments - could also happen that someone adds a filename with special characters just in case it does not go through same code
Good...
January 28, 2021 at 3:25 pm
Hi Thom. Thanks again for doing this testing. I had forgotten about tags and categories, but I do see that you were able to add "Alien Monster" to them. Cool....
January 27, 2021 at 11:30 pm
Great! Glad to hear that the testing so far is looking positive. Do you mind a few more tests, just to help make sure that other scenarios work, or at...
January 19, 2021 at 5:22 am
Yer welcome. And, no worries. 2020 wasn't a great month for me (and it was terribly long) ;-). Just let me know what you observe. If it works I will...
January 13, 2021 at 5:49 am
Hey Thom. I think I found a potential fix for this issue. I actually have two solutions, but one requires setting up the Project Nami DB to use a _UTF8...
December 10, 2020 at 6:08 am
Thanks, everyone!
Sue_H, I followed the article and walked through the steps carefully. Thank you for posting it!
...
Following the steps in that link above, I was able to...
December 10, 2020 at 3:09 am
Hi Steve. Good question. Not to be too nit-picky about the wording, but the title of the question is slightly misleading given that none of the datatypes store the actual...
November 9, 2020 at 6:28 pm
Test post:
trying to see if the following character is converted to a best-fit mapping: 〛
]
If it comes back as a regular ] then it is being converted via best-fit, which...
November 6, 2020 at 9:11 pm
I haven't found the specific cause yet, but I am getting closer. I did just find, and submit a fix / PR for, an occasionally serious bug:
You are right Solomon, restarting the SSMS instance brings back 100,000 characters.
😎
The default server collation is Latin1_General_CI_AS
Sorry, I realize now that I said "query window", but I meant to...
November 5, 2020 at 6:19 am
Regarding the explanation for the correct answer, the reason for why it couldn't be 10,000 is correct. But, the first part regarding VARCHAR , NVARCHAR , and UTF-8 could use...
November 4, 2020 at 5:52 am
I realized the SSMS settings affecting the results as soon as I posted, got a fresh install on this laptop ("Vanilla") SQL Server Management Studio 15.0.18338.0
😎
The SQL Server is
Microsoft...
November 4, 2020 at 3:38 am
On SQL 2019, the results are 8000 and 65536 characters respectfully, starting to sound like some presidential election....
What patch level are you using? I am testing your code on...
November 3, 2020 at 7:15 pm
Looks like it's upstream though, as I tested on a Project Nami install I have and experienced the same problem. I'll see if i can find the problem myself...
November 3, 2020 at 4:56 pm
Hi all. I have replied to Thom's forum post regarding storing data in NVARCHAR . I mentioned in my reply that Unicode characters can be stored...
November 3, 2020 at 4:22 pm
Viewing 15 posts - 16 through 30 (of 645 total)