Only Coders

python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - nvarchar

national characters in Oracle

we are using Oracle 19c there are setting in nls_database_parameters nls_nchar_characterset is UTF8 nls_charchterset is WE8ISO8859P15 I have a table with one column of varchar2 and another column of n...

Pato

oracle

char

oracle19c

nvarchar

Votes: 0

Answers: 0

From Varchar to Nvarchar with 'N' prefix

I have a table with thousands of rows. One of the columns does not read the values correctly. Some letters cannot be recognised and thus changed to some symbols like in the attached screenshot. I foun...

Farkhod Giyasov

sql

oracle

varchar

nvarchar

Votes: 0

Answers: 1

Latest Answer

CREATE TABLE fg_test_geo( budesland VARCHAR(30) ,nbudesland NVARCHAR(30) ); INSERT INTO fg_test_geo(budesland,nbudesland) VALUES ('bucurești',N'bucurești'); We could alter the existing varch...

Paul Maxwell

Converting nvarchar to int, converting phone with symbols with only numbers

I am trying to convert phone number from the column 'phone' from the table 'Clients'. I have tried the following syntaxes, but I still get error messages - 1. SELECT CAST(phone as int) FROM Clients...

Learn Freak

sql

sql-server

integer

nvarchar

Votes: 0

Answers: 2

Latest Answer

Because at least some of your records cannot be covert to numeric by default, as the indicated one 030-3456789 You basically need to replace/eliminate the dash in between: SELECT cast(replace('12-3', ...

QPeiran

Why is a Variable declared as NVARCHAR(MAX) dropping chunks of the string?

For whatever reason, a query is being built as a string and passed off to be executed by another stored procedure. The query is massive. Over a thousand lines, and we've run into an issue that require...

Will

sql-server

max

nvarchar

Votes: 0

Answers: 1

Latest Answer

This is working fine for me: DECLARE @sql nvarchar(max) = REPLICATE(CONVERT(nvarchar(max), N'a'), 4000) + REPLICATE(CONVERT(nvarchar(max), N'b'), 4000) + REPLICATE(CONVERT(nvarchar(max), N'c'...

Aaron Bertrand

Posts

Questions

Blogs

Jobs