Forum Replies Created

Viewing 15 posts - 16 through 30 (of 646 total)

  • Reply To: UTF8 and varchar lengths

    Eirikur Eiriksson wrote:

    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...

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

    November 5, 2020 at 6:19 am

    #3804497

  • Reply To: UTF8 and varchar lengths

    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...

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

    November 4, 2020 at 5:52 am

    #3804124

  • Reply To: UTF8 and varchar lengths

    Eirikur Eiriksson wrote:

    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...

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

    November 4, 2020 at 3:38 am

    #3804111

  • Reply To: UTF8 and varchar lengths

    Eirikur Eiriksson wrote:

    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...

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

    November 3, 2020 at 7:15 pm

    #3803996

  • Reply To: Can post please be stored in nvarchar?

    Thom A wrote:

    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...

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

    November 3, 2020 at 4:56 pm

    #3803955

  • Reply To: UTF8 and varchar lengths

    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...

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

    November 3, 2020 at 4:22 pm

    #3803935

    • Viewing 15 posts - 16 through 30 (of 646 total)