Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Science

BootinUp

(50,098 posts)

9. So is it due to a difference in how the results are sorted?

Reply to Hugh_Lebowski (Reply #5)

Wed Mar 1, 2023, 11:18 PM

Mar 2023

Not too long ago I worked out why a query didn't sort like I expected it to. A dash character in a NCHAR data type was what made it sort strangely. NCHAR type is unicode. I changed the data type to CHAR and that worked for me. Been too long since I worked with MySQL 9 years, to remember specifics about it.

Edit: It could have been NVARCHAR to VARCHAR too, I don't do this stuff everyday.

Edit history

Please sign in to view edit histories.

Recommendations

0 members have recommended this reply (displayed in chronological order):

11 replies

= new reply since forum marked as read

Highlight:

Python 3.14 Will be Faster than C++ (Not really) [View all] BootinUp Mar 2023 OP

Our shop has some big Python projects coming up and I've been asked to familiarize myself Hugh_Lebowski Mar 2023 #1

I setup and run a little sql server BootinUp Mar 2023 #2

MS Sql Server is my main jam, and our biggest client uses it Hugh_Lebowski Mar 2023 #5

Currently I use the MS product but I have BootinUp Mar 2023 #6

So is it due to a difference in how the results are sorted? BootinUp Mar 2023 #9

I assume this was some sort of joke lapfog_1 Mar 2023 #3

I guess you were bored and didnt BootinUp Mar 2023 #4

lol, I wrote a text preprocessor and HTML generator in R once mike_c Mar 2023 #7

I just used R to format and export data from MS SQL BootinUp Mar 2023 #8

You are SO right: It is the entire development cycle which is important SorellaLaBefana Apr 2023 #11

Python-based compiler achieves orders-of-magnitude speedups Jim__ Mar 2023 #10