Let database work for your daily life
I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but...
2005-09-11
1,338 reads
Blog Posts
about xp_sendmail
I got a very interesting issue, I may guess the reason but not sure why it is this way.
Symptom: Logon to...
2005-09-09
1,376 reads
Careful Blogging
I still not sure that this blog service was a great idea, but some of
you seem to like it, so...
2005-09-08
1,374 reads
one issue about SQL 2000 BOL
This is my first post, congrats to myself. 🙂
DTS Connection object does not list "UseTrustedConnection" property
I am working on a...
2005-09-08
1,348 reads
In praise of three day weekends!
I guess it might be because I have been so busy for the last two months with the book, but this...
2005-09-05
1,235 reads
Head back up above water
I've spent the last few weeks writing SOX documentation, more SOX
documentation, and even more SOX documentation. A lot the documentation
doesn't...
2005-09-02
1,388 reads
Of anarchy and thin veneers...
Following the horrifying stories that are unfolding in the aftermath of
Katrina, it is difficult for the mind to single out...
2005-09-02
1,312 reads
The Data Center in New Orleans
There's a blog running at LiveJournal from one of the guys at directnic. There's evidently an ISP that is still...
2005-09-02
1,465 reads
Blessed to live in the boring MidWest
The images on the TV news this morning were surreal. Hundereds of people dead, missing, homeless because of Katrina and...
2005-08-31
1,271 reads
Plagiarism
Seen this from Kevin Kline?
We went back and forth along with a few others this morning looking at
the many places,...
2005-08-30
1,606 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers