Commit101c8ae

committed

Doc: explain that the string types can't store \0 (ASCII NUL).

This restriction was mentioned in connection with string literals,but it wasn't made clear that it's a general restriction not justa syntactic limitation in query strings.Per unsigned documentation comment.Discussion:https://postgr.es/m/160720552914.710.16625261471128631268@wrigleys.postgresql.org

1 parentd7ecba9 commit101c8aeCopy full SHA for 101c8ae

File tree

-4

lines changed

-4

lines changed

Lines changed: 9 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1149,6 +1149,14 @@ SELECT '52093.89'::money::numeric::float8;`
`1149`	`1149`	`regular expressions.`
`1150`	`1150`	`</para>`
`1151`	`1151`
	`1152`	`+ <para>`
	`1153`	`+ The characters that can be stored in any of these data types are`
	`1154`	`+ determined by the database character set, which is selected when`
	`1155`	`+ the database is created. Regardless of the specific character set,`
	`1156`	`+ the character with code zero (sometimes called NUL) cannot be stored.`
	`1157`	`+ For more information refer to <xref linkend="multibyte"/>.`
	`1158`	`+ </para>`
	`1159`	`+`
`1152`	`1160`	`<para>`
`1153`	`1161`	`The storage requirement for a short string (up to 126 bytes) is 1 byte`
`1154`	`1162`	`plus the actual string, which includes the space padding in the case of`
`@@ -1186,10 +1194,7 @@ SELECT '52093.89'::money::numeric::float8;`
`1186`	`1194`	`<para>`
`1187`	`1195`	`Refer to <xref linkend="sql-syntax-strings"/> for information about`
`1188`	`1196`	`the syntax of string literals, and to <xref linkend="functions"/>`
`1189`		`- for information about available operators and functions. The`
`1190`		`- database character set determines the character set used to store`
`1191`		`- textual values; for more information on character set support,`
`1192`		`- refer to <xref linkend="multibyte"/>.`
	`1197`	`+ for information about available operators and functions.`
`1193`	`1198`	`</para>`
`1194`	`1199`
`1195`	`1200`	`<example>`

Comments

(0)