Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Line breaks in the field - how can I see them?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01293940
Message ID:
01294295
Vues:
19
>>Have no clue.
>>I have no idea why your front end don;t present the data properly.
>>Maybe if you ask that question n NET forum,...?
>
>First I need to find out the code producing the output.
>
>BTW, how can we see in SQL Server IDE the actual content of the field (with the line breaks)?

Don't know. I can't find any settings to show non printable chars in the result.
With this:
CREATE DATABASE Test
GO
USE Test
CREATE TABLE Test (Fld1 varchar(200))
insert into Test VALUES ('asdasdasdasdas'+CHAR(13)+CHAR(10)+'asdasdasdasdasdasdasdasdasdasdasda')
And then OPEN table from Object browser I can see two squares in the place of CHAR(13)+CHAR(10). But can't find a way to see them when I just run
SELECT * from Test in New Query window.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform