SqlSrv extends AbstractPlatform
This class is only meant to be used within EXT:install and is not part of the TYPO3 Core API.
Table of Contents
Constants
- SCHEMA_NAME_MAX_LENGTH = 128
- https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers
Properties
- $databaseCharsetToCheck : array<string|int, mixed>
- SQL Server has a more complex naming schema for the collation.
- $databaseServerCharsetToCheck : array<string|int, mixed>
- SQL Server has a more complex naming schema for the collation.
- $messageQueue : FlashMessageQueue
Methods
- __construct() : mixed
- checkDefaultDatabaseCharset() : void
- Checks the character set of the database and reports an error if it is not utf-8.
- checkDefaultDatabaseServerCharset() : void
- Checks the character set of the database server and reports an info if it is not utf-8.
- getMessageQueue() : FlashMessageQueue
- getStatus() : FlashMessageQueue
- Get all status information as array with status objects
- isValidDatabaseName() : bool
- Validate the database name https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers
- checkDatabaseName() : void
Constants
SCHEMA_NAME_MAX_LENGTH
https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers
protected
int
SCHEMA_NAME_MAX_LENGTH
= 128
The maximum length of the schema name
Properties
$databaseCharsetToCheck
SQL Server has a more complex naming schema for the collation.
protected
array<string|int, mixed>
$databaseCharsetToCheck
= ['_UTF8']
For more information visit: https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support
Thus we need to check, whether the charset set here is part of the collation.
$databaseServerCharsetToCheck
SQL Server has a more complex naming schema for the collation.
protected
array<string|int, mixed>
$databaseServerCharsetToCheck
= ['_UTF8']
For more information visit: https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support
Thus we need to check, whether the charset set here is part of the collation.
$messageQueue
protected
FlashMessageQueue
$messageQueue
Methods
__construct()
public
__construct() : mixed
checkDefaultDatabaseCharset()
Checks the character set of the database and reports an error if it is not utf-8.
public
checkDefaultDatabaseCharset(Connection $connection) : void
Parameters
- $connection : Connection
-
to the database to be checked
checkDefaultDatabaseServerCharset()
Checks the character set of the database server and reports an info if it is not utf-8.
public
checkDefaultDatabaseServerCharset(Connection $connection) : void
Parameters
- $connection : Connection
-
to the database to be checked
getMessageQueue()
public
getMessageQueue() : FlashMessageQueue
Return values
FlashMessageQueuegetStatus()
Get all status information as array with status objects
public
getStatus() : FlashMessageQueue
Tags
Return values
FlashMessageQueueisValidDatabaseName()
Validate the database name https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers
public
static isValidDatabaseName(string $databaseName) : bool
Examples:
valid:
_foo @foo #foo _floo1äea @foo111111111kemcie_l#@
not valid:
@@thisShouldNotBeValid
Parameters
- $databaseName : string
Return values
boolcheckDatabaseName()
protected
checkDatabaseName(Connection $connection) : void
Parameters
- $connection : Connection